CREATE TABLE [dbo].[CreditCard]
(
[编号] [int] NOT NULL IDENTITY(1, 1),
[银行] [int] NULL,
[银行卡号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[备注] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[是否开通网银] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CreditCard] ADD CONSTRAINT [PK__CreditCa__1DF06E6E03317E3D] PRIMARY KEY CLUSTERED  ([编号]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CreditCard] ADD CONSTRAINT [FK__CreditCard__银行__0519C6AF] FOREIGN KEY ([银行]) REFERENCES [dbo].[Bank] ([编号])
GO
